<?php
/* -------------------------------------------------------------------------------------
* 	ID:						$Id: stats_campaigns.php 112 2013-09-21 12:08:24Z phone.mueller@googlemail.com $
* 	Letzter Stand:			$Revision: 112 $
* 	zuletzt geaendert von:	$Author: siekiera $
* 	Datum:					$Date: 2013-09-21 12:08:24 +0000 (Sat, 21 Sep 2013) $
*
* 	SEO:mercari by Siekiera Media
* 	http://www.seo-mercari.de
*
* 	Copyright (c) since 2011 SEO:mercari
* --------------------------------------------------------------------------------------
* 	based on:
* 	(c) 2000-2001 The Exchange Project  (earlier name of osCommerce)
* 	(c) 2002-2003 osCommerce - www.oscommerce.com
* 	(c) 2003     nextcommerce - www.nextcommerce.org
* 	(c) 2005     xt:Commerce - www.xt-commerce.com
*
* 	Released under the GNU General Public License
* ----------------------------------------------------------------------------------- */


require ('includes/application_top.php');

require (DIR_WS_CLASSES.'currencies.php');
$currencies = new currencies();

require (DIR_WS_CLASSES.'campaigns.php');
$campaign = new campaigns($_GET);

$srDefaultView = '2';

$orders_statuses = array ();
$orders_status_array = array ();
$orders_status = $db->db_query("SELECT orders_status_id, orders_status_name from ".TABLE_ORDERS_STATUS." WHERE language_id = '".$_SESSION['languages_id']."'");
while (!$orders_status->EOF) {
	$orders_statuses[] = array ('id' => $orders_status->fields['orders_status_id'], 'text' => $orders_status->fields['orders_status_name']);
	$orders_status_array[$orders_status->fields['orders_status_id']] = $orders_status->fields['orders_status_name'];
	$orders_status->MoveNext();
}

$campaigns = array ();
$campaign_data = $db->db_query("SELECT * FROM ".TABLE_CAMPAIGNS);

while (!$campaign_data->EOF) {
	$campaigns[] = array ('id' => $campaign_data->fields['campaigns_refID'], 'text' => $campaign_data->fields['campaigns_name']);
	$campaign_data->MoveNext();
}

// report views (1: yearly 2: monthly 3: weekly 4: daily)
if (($_GET['report']) && (not_null($_GET['report']))) {
	$srView = $_GET['report'];
}
if ($srView < 1 || $srView > 4) {
	$srView = $srDefaultView;
}

// check start and end Date
$startDate = '';
$startDateG = 0;
if (($_GET['startD']) && (not_null($_GET['startD']))) {
	$sDay = $_GET['startD'];
	$startDateG = 1;
} else {
	$sDay = 1;
}
if (($_GET['startM']) && (not_null($_GET['startM']))) {
	$sMon = $_GET['startM'];
	$startDateG = 1;
} else {
	$sMon = 1;
}
if (($_GET['startY']) && (not_null($_GET['startY']))) {
	$sYear = $_GET['startY'];
	$startDateG = 1;
} else {
	$sYear = date("Y");
}
if ($startDateG) {
	$startDate = mktime(0, 0, 0, $sMon, $sDay, $sYear);
} else {
	$startDate = mktime(0, 0, 0, date("m"), 1, date("Y"));
}

$endDate = "";
$endDateG = 0;
if (($_GET['endD']) && (not_null($_GET['endD']))) {
	$eDay = $_GET['endD'];
	$endDateG = 1;
} else {
	$eDay = 1;
}
if (($_GET['endM']) && (not_null($_GET['endM']))) {
	$eMon = $_GET['endM'];
	$endDateG = 1;
} else {
	$eMon = 1;
}
if (($_GET['endY']) && (not_null($_GET['endY']))) {
	$eYear = $_GET['endY'];
	$endDateG = 1;
} else {
	$eYear = date("Y");
}
if ($endDateG) {
	$endDate = mktime(0, 0, 0, $eMon, $eDay +1, $eYear);
} else {
	$endDate = mktime(0, 0, 0, date("m"), date("d") + 1, date("Y"));
}
require(DIR_WS_INCLUDES.'metatag.php');
?>
</head>
<body>
<?php
require (DIR_WS_INCLUDES.'header.php');
?>
<div id="wrapper">
<table class="outerTable" cellspacing="0" cellpadding="0">
  <tr>
	<td class="columnLeft2" width="<?php echo BOX_WIDTH; ?>" valign="top">
		<table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
			<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
		</table>
	</td>
    <td class="boxCenter" valign="top">
      <table border="0" width="100%" cellspacing="0" cellpadding="2">
        <tr>
          <td colspan=2>
            <table border="0" width="100%" cellspacing="0" cellpadding="0">
  				<tr>
				    <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
				</tr>
			</table>
          </td>
        </tr>
		<?php
		if ($srExp < 1) {
		?>
        <tr>
          <td colspan="2">
            <form action="" method="get">
              <table border="0" style="border: 1px solid; border-color: #cccccc;" width="100%" cellspacing="0" cellpadding="0">
                <tr>
                  <td align="left" rowspan="2" class="menuBoxHeading">
                    <input type="radio" name="report" value="1" <?php if ($srView == 1) echo "checked"; ?>><?php echo REPORT_TYPE_YEARLY; ?><br />
                    <input type="radio" name="report" value="2" <?php if ($srView == 2) echo "checked"; ?>><?php echo REPORT_TYPE_MONTHLY; ?><br />
                    <input type="radio" name="report" value="3" <?php if ($srView == 3) echo "checked"; ?>><?php echo REPORT_TYPE_WEEKLY; ?><br />
                    <input type="radio" name="report" value="4" <?php if ($srView == 4) echo "checked"; ?>><?php echo REPORT_TYPE_DAILY; ?><br />
                  </td>
                  <td class="menuBoxHeading">
<?php echo REPORT_START_DATE; ?><br />
                    <SELECT name="startD" size="1">
<?php

	if ($startDate) {
		$j = date("j", $startDate);
	} else {
		$j = 1;
	}
	for ($i = 1; $i < 32; $i ++) {
?>
                        <option<?php if ($j == $i) echo " selected"; ?>><?php echo $i; ?></option>
<?php

	}
?>
                    </select>
                    <SELECT name="startM" size="1">
<?php

	if ($startDate) {
		$m = date("n", $startDate);
	} else {
		$m = 1;
	}
	for ($i = 1; $i < 13; $i ++) {
?>
                      <option<?php if ($m == $i) echo " selected"; ?> value="<?php echo $i; ?>"><?php echo strftime("%B", mktime(0, 0, 0, $i, 1)); ?></option>
<?php

	}
?>
                    </select>
                    <SELECT name="startY" size="1">
<?php

	if ($startDate) {
		$y = date("Y") - date("Y", $startDate);
	} else {
		$y = 0;
	}
	for ($i = 10; $i >= 0; $i --) {
?>
                      <option<?php if ($y == $i) echo " selected"; ?>><?php echo date("Y") - $i; ?></option>
<?php

	}
?>
                    </select>
                  </td>
                  <td rowspan="2" align="left" class="menuBoxHeading"> <?php echo REPORT_STATUS_FILTER; ?><br /> 
                    <?php echo draw_pull_down_menu('status', array_merge(array(array('id' => '0', 'text' => REPORT_ALL)), $orders_statuses), $_GET['status']); ?> 
                    
                    <br><?php echo REPORT_CAMPAIGN_FILTER; ?><br /> 
<?php echo draw_pull_down_menu('campaign', array_merge(array(array('id' => '0', 'text' => REPORT_ALL)), $campaigns), $_GET['campaign']); ?> 
                    
                    </td>
                  <td rowspan="2" align="left" class="menuBoxHeading"><br />
                  </td>
                  <td rowspan="2" align="left" class="menuBoxHeading"> <br />
                  </td>
                </tr>
                <tr>
                  <td class="menuBoxHeading">
<?php echo REPORT_END_DATE; ?><br />
                    <SELECT name="endD" size="1">
<?php

	if ($endDate) {
		$j = date("j", $endDate -60 * 60 * 24);
	} else {
		$j = date("j");
	}
	for ($i = 1; $i < 32; $i ++) {
?>
                      <option<?php if ($j == $i) echo " selected"; ?>><?php echo $i; ?></option>
<?php

	}
?>
                    </select>
                    <SELECT name="endM" size="1">
<?php

	if ($endDate) {
		$m = date("n", $endDate -60 * 60 * 24);
	} else {
		$m = date("n");
	}
	for ($i = 1; $i < 13; $i ++) {
?>
                      <option<?php if ($m == $i) echo " selected"; ?> value="<?php echo $i; ?>"><?php echo strftime("%B", mktime(0, 0, 0, $i, 1)); ?></option>
<?php

	}
?>
                    </select>
                    <SELECT name="endY" size="1">
<?php

	if ($endDate) {
		$y = date("Y") - date("Y", $endDate -60 * 60 * 24);
	} else {
		$y = 0;
	}
	for ($i = 10; $i >= 0; $i --) {
?>
                      <option<?php if ($y == $i) echo " selected"; ?>><?php

		echo date("Y") - $i;
?></option><?php

	}
?>
                    </select>
                  </td>
                </tr>
                <tr>
                  <td colspan="5" class="menuBoxHeading" align="right">
                  <?php echo '<input type="submit" class="button" onClick="this.blur();" value="' . BUTTON_UPDATE . '"/>'; ?>
                  </td>
              </table>
            </form>
          </td>
        </tr>
<?php

} // end of ($srExp < 1)
?>
        <tr>
          <td width=100% valign=top>
            <table border="0" width="100%" cellspacing="0" cellpadding="2">
              <tr>
                <td valign="top">
 <?php

if (count($campaign->result)) {
?>               
                
                
    
    
    
 <table border="0" width="100%" cellspacing="0" cellpadding="2">
 
   <tr class="dataTableHeadingRow"> 
    <td class="dataTableHeadingContent" colspan="2" width="25%"><?php echo HEADING_TOTAL; ?></td>
    <td class="dataTableHeadingContent" width="10%">&nbsp;</td>
    <td class="dataTableHeadingContent" width="15%"><?php echo $campaign->total['leads']; ?></td>
    <td class="dataTableHeadingContent" colspan="2" width="30%"><?php echo $campaign->total['sells']; ?></td>
    <td class="dataTableHeadingContent" width="20%"><?php echo $campaign->total['sum']; ?></td>
  </tr>
  <tr class="dataTableHeadingRow"> 
    <td class="dataTableHeadingContent" colspan="2" width="25%">&nbsp;</td>
    <td class="dataTableHeadingContent" width="10%"><?php echo HEADING_HITS; ?></td>
    <td class="dataTableHeadingContent" width="15%"><?php echo HEADING_LEADS; ?></td>
    <td class="dataTableHeadingContent" width="15%"><?php echo HEADING_SELLS; ?></td>
    <td class="dataTableHeadingContent" width="15%"><?php echo HEADING_LATESELLS; ?></td>
    <td class="dataTableHeadingContent" width="20%"><?php echo HEADING_SUM; ?></td>
  </tr>
  
 <?php

	// show campaigns

	for ($n = 0; $n < count($campaign->result); $n ++) {
?>
  
  
  
  
  <tr class="dataTableRow"> 
    <td class="main" colspan="7" style="border-bottom: 2px solid;"><br><?php echo $campaign->result[$n]['text'].' '.TEXT_REFERER .' ('.$campaign->result[$n]['id'].')'; ?></td>
  </tr>
  
  <?php
		// show values
		for ($nn = 0; $nn < count($campaign->result[$n]['result']); $nn ++) {
?>
  
  				<tr class="dataTableRow"> 
				    <td class="dataTableContent">&nbsp;</td>
				    <td class="dataTableContent"><?php echo $campaign->result[$n]['result'][$nn]['range']; ?></td>
				    <td class="dataTableContent"><?php echo $campaign->result[$n]['result'][$nn]['hits']; ?></td>
				    <td class="dataTableContent"><?php echo $campaign->result[$n]['result'][$nn]['leads'].' ('.$campaign->result[$n]['result'][$nn]['leads_p'].'%)'; ?></td>
				    <td class="dataTableContent"><?php echo $campaign->result[$n]['result'][$nn]['sells'].' ('.$campaign->result[$n]['result'][$nn]['sells_p'].'%)'; ?></td>
				    <td class="dataTableContent"><?php echo $campaign->result[$n]['result'][$nn]['late_sells'].' ('.$campaign->result[$n]['result'][$nn]['late_sells_p'].'%)'; ?></td>
				    <td class="dataTableContent"><?php echo $campaign->result[$n]['result'][$nn]['sum'].' ('.$campaign->result[$n]['result'][$nn]['sum_p'].'%)'; ?></td>
				 </tr>
				  <?php
					}
				?>
   				 <tr class="dataTableRow"> 
				    <td class="dataTableContent"><b><?php echo HEADING_SUM; ?></b></td>
				    <td class="dataTableContent">&nbsp;</td>
				    <td class="dataTableContent"><b><?php echo $campaign->result[$n]['hits_s']; ?></b></td>
				    <td class="dataTableContent"><b><?php echo $campaign->result[$n]['leads_s'].' ('.($campaign->total['leads']> 0 ? ($campaign->result[$n]['leads_s']/$campaign->total['leads']*100):'0').'%)'; ?></b></td>
				    <td class="dataTableContent"><b><?php echo $campaign->result[$n]['sells_s'].' ('.($campaign->total['sells']> 0 ? ($campaign->result[$n]['sells_s']/$campaign->total['sells']*100):'0').'%)'; ?></b></td>
				    <td class="dataTableContent"><b><?php echo $campaign->result[$n]['late_sells_s'].' ('.($campaign->total['sells']> 0 ? ($campaign->result[$n]['late_sells_s']/$campaign->total['sells']*100):'0').'%)'; ?></b></td>
				    <td class="dataTableContent"><b><?php echo $campaign->result[$n]['sum_s'].' ('.($campaign->total['sum_plain']> 0 ? round(($campaign->result[$n]['sum_s']/$campaign->total['sum_plain']*100),0):'0').'%)'; ?></b></td>
				  </tr>
				  <?php
					}
				?>
				</table>
				<?php } ?>
                &nbsp; </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
</div>
<?php
	require (DIR_WS_INCLUDES.'footer.php');
?>
</body>
</html>
<?php
	require (DIR_WS_INCLUDES.'application_bottom.php');
?>